package com.itcs.trading.mapper;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Select;

import com.itcs.trading.model.UserRechangeOpHis;

public interface UserRechangeOpHisMapper {
    int deleteByPrimaryKey(Long rechargeNo);

    int insert(UserRechangeOpHis record);

    int insertSelective(UserRechangeOpHis record);

    UserRechangeOpHis selectByPrimaryKey(Long rechargeNo);

    int updateByPrimaryKeySelective(UserRechangeOpHis record);

    int updateByPrimaryKey(UserRechangeOpHis record);
    //查出该用户下所有的充值记录条数
    @Select("select count(*) from  user_rechange_op_jnl where user_id = #{userId,jdbcType=BIGINT}")
    int qryCount(Long param);
    //查询当前页下该用户的充值记录
   @Select("select * from  user_rechange_op_jnl where user_id = #{userId,jdbcType=BIGINT} limit #{pageStart},#{pageSize}")
    List<Map<String,Object>> qryRechareList(Map<String,Object> paramMap);
}